Export Timesheets Screen
Use the Export Timesheets screen to export timesheets to a labor staging table or payroll staging table, using the values set up for the Labor Distribution and Manage Payroll options on the Manage Timesheet Classes screen.
In most cases, timesheets must be approved before you can export them. However, you have the option to export in-process (unapproved) timesheets for those timesheet classes that are set up to allow it.
The timesheet transaction remains in these staging tables for pickup, or the export application may call a transformer to transform the table entries into a specific ASCII layout.
Location
To display the Export Timesheets screen, complete the following step:
- Click .
Contents
Screen Fields
Field | Description |
---|---|
Timesheets |
Select the type of timesheets that you want to export. The following timesheet types are available:
Note: If Time & Expense is not set up to export in-process timesheets, you can only export approved timesheets.
|
Subcontractor Export |
When selected, this check box differentiates subcontractor timesheets from the timesheets of regular employees. Additionally, all other screen options are disabled, because only the subcontractor data displays. When processing of the export is finished, the data is exported to Costpoint, where the prime contractor can create a subcontractor invoice. |
Reload Defaults | Click this button if, having entered new values, you want to revert to the previously saved default values. |
Save Defaults |
Click this button to save the currently selected options as default values. When you click
Save Defaults, values entered in the following fields are either saved or not saved as indicated in the following list:
|
Batch ID |
Enter a unique export batch identifier of up to 10 alphanumeric characters. You cannot enter a previously used batch ID. Note: The name of the exported file is based on the batch ID.
|
ADP File Name |
In ADP File Name, enter the file name for the payroll file to be exported to ADP. This field only appears if Time & Expense is set up to export payroll information to ADP. |
Costpoint Company |
Click to select the Costpoint company for which you are exporting timesheets. The Costpoint companies available for selection are those for which the specified type of timesheets (approved or in-process) exist for the selected timesheet period. This field only appears if the Costpoint Multicompany check box is selected in the Miscellaneous tab of the Configure General Settings screen. The Costpoint interface allows only one company to be exported at a time. |
Export File |
This read-only field displays the name of the export file. The location where the file is saved displays as a prefix to the filename. The location is configured in . |
Export Options
Field | Description |
---|---|
Export Work Schedules |
Select this check box to export your company's work schedule information. This option is only available for Costpoint 7.x or higher, and the check box is only enabled if the ASCII Layout option is Costpoint 7.x or Greater on the Time ›› Settings ›› Time Configuration ›› Export Options tab. To support salary proration, Costpoint 7.x includes a work schedule. In cases where you do not have direct connectivity between Costpoint and Time & Expense, it is necessary to export your work schedule information to Costpoint using a comma delimited file that will contain the company level work schedule data as described in the following:
|
Make Next Period Current | Select this check box to make the next period current. |
Export Directly to Costpoint | Select this check box to automatically execute the import of timesheets into Costpoint at the same time as they are exported from Time & Expense. You can set the Costpoint import parameters in the Export to Costpoint section of this screen. |
Print Options
In this section, select the type of report you want to print.
Field | Description |
---|---|
Labor Distribution | This option is available if the timesheet classes you selected are configured for labor exports. |
Include Detail |
Select this option if you want the Labor Distribution report to include the first six UDTs, charge descriptions, and cell date and hours for the exported records of each employee. If you do not select this option, the Labor Summary report prints instead, which shows the same information summarized at the line level, and hours are not broken down by date. |
Payroll | This option is available if the timesheet classes you selected are configured for payroll exports. |
Include Detail |
Select this option if you want the Payroll report to include the pay types, payroll codes, payroll earnings code, and hours for the employees and timesheet classes. If you do not select this option, the Payroll Summary report prints, which does not include the breakdown by employee or timesheet class. |
Export to Costpoint Options
In this section, select the type of report you want to print.
Field | Description |
---|---|
Timesheet Start Date | This option is available if the timesheet classes you selected are configured for labor exports. |
Timesheet End Date |
Select this option if you want the Labor Distribution report to include the first six UDTs, charge descriptions, and cell date and hours for the exported records of each employee. If you do not select this option, the Labor Summary report prints instead, which shows the same information summarized at the line level, and hours are not broken down by date. |
Fiscal Year | This option is available if the timesheet classes you selected are configured for payroll exports. |
Period |
Select this option if you want the Payroll report to include the pay types, payroll codes, payroll earnings code, and hours for the employees and timesheet classes. If you do not select this option, the Payroll Summary report prints, which does not include the breakdown by employee or timesheet class. |
Subperiod |
Select this option if you want the Payroll report to include the pay types, payroll codes, payroll earnings code, and hours for the employees and timesheet classes. If you do not select this option, the Payroll Summary report prints, which does not include the breakdown by employee or timesheet class. |
Auto-Adjust Salaried Employees | Select this check box to auto adjust timesheets for salaried employees. This check box is available only if the
Enable for Salaried Employees check box is selected in the
Selective Auto-Adjust group box on the Overtime Settings subtask of the
screen.
Note: C type timesheets are not auto-adjusted when imported into Costpoint.
|
Auto-Adjust Hourly Employees | Select this check box to auto adjust timesheets for hourly employees. This check box is available only if the
Enable for Hourly Employees
check box is selected in the
Selective Auto-Adjust group box on the Overtime Settings subtask of the
screen.
Note: C type timesheets are not auto-adjusted when imported into Costpoint
|
Override Auto Adjust % | Enter the auto adjust percentage to be applied. If you do not specify an
Override Auto Adjust %, Costpoint uses the Default Auto-Adjust % on the
screen for the employee's timesheet cycle.
The rules for Auto-Adjustment of D and N Type Timesheets are as follows:
Note: The D and N type timesheets are considered separate timesheets until they are inserted into TS_HDR and TS_LN (basically, they are never rolled up into one timesheet). They are auto-adjusted as separate timesheets.
The assumptions for D and N Type Timesheets are as follows:
|
Timesheet Type | From the drop-down list, select the timesheet type to be used as a default if there is no timesheet type in the input file. This does not override values entered in the input file. Valid options are:
|
Effective Bill Date Override | Enter, or click to select, a date to override the effective bill date Default Method from the Configure Labor Settings screen. |
Roll Up Timesheet Dates | Select this check box to
ignore dates in the input file and put all records on one timesheet.
Note: If you select this check box, the End Date specified in the Timesheet Dates range will used as the timesheet date for the imported records.
If the Calculation Method in the Prorate Options group box in the Configure Labor Settings screen is Days Per Cycle, this check box is cleared and disabled. |
Roll Up Timesheet Lines | Select this check box to add together lines in the input file when they belong to the same account, project, organization, and so forth. If the Withholding State differs, the lines are not rolled up.
If the Calculation Method in the Prorate Options group box in the Configure Labor Settings screen is Days per Cycle, this check box is cleared and disabled. |
Parse Segmented IDs | Select this check box to format segmented IDs. Segmented ID fields are Costpoint fields (such as account, organization, project, reference number 1, reference number 2, project report, and organization) that require segment separators (periods or dashes). If you select this check box, the upload takes longer. |
Prorate Salaried Employees | Select this check box to prorate labor costs for salaried employees in the final upload of the timesheet cycle. If the Calculation Method in the Prorate Options group box in the Configure Labor Settings screen is None, this check box is cleared and disabled |
Generate Union Fringe | Select this check box to have Costpoint calculate applicable union cash fringes when you import a timesheet for a union employee. This check box is enabled only if the Enable Union Functionality check box is selected on the Configure Labor Settings screen. Union cash fringe timesheet lines are built according to settings on the screen |
Timesheets Periods Table
This table displays the periods for those timesheets that are eligible for exporting.
If Time & Expense is set up to allow the export of timesheets for only one timesheet period at a time, select the period for which you want to export timesheets.
If Time & Expense is set up to allow the export of timesheets for more than one timesheet period at a time, click the check box at the top of the table to select all rows.
Field | Description |
---|---|
Timesheet Period |
This column lists the timesheet periods for which eligible timesheets exist. If Timesheets contain Approved, the column contains all timesheet periods for which approved timesheets exist. If Timesheets contain In-Process, the column contains all timesheet periods for which open timesheets exist; these, typically, are for employees assigned to timesheet classes that allow the exporting of in-process timesheets. |
Selected |
A check mark indicates a row is selected and will be included in the export results. Click the check box to select or clear a row. |
Start Date |
Press Enter to accept the displayed date or click to select the beginning timesheet period date. Only timesheet cell records dated between the starting and ending dates are exported. |
End Date |
The default date in End Date is the selected timesheet period's ending date. Click to the right of the field to select a different end date. Only timesheet cell records dated between the start and end dates are exported. |
Timesheet Date |
The default date in Timesheet Date is the selected timesheet period's ending date. Click to the right of the field to select a different timesheet date. This date is shown as the timesheet date on the cover page of the Export Timesheets Report. |
Groups
This table displays the employee groups that have timesheets with the required status and timesheet period. The only groups that display are those for which you are the designated supervisor.
Field | Description |
---|---|
Selected |
A check mark indicates a row is selected and will be included in the export results. Click the check box to select or clear a row. You can select individual rows or click Select All to select all the records in the table. |
Type | This field displays the employee group type description. |
Group | This field displays the employee group. |
Classes
This table displays the timesheet classes that contain employees who have timesheets with the required status and timesheet period. The only groups that display are those for which you are the designated supervisor.
Field | Description |
---|---|
Selected |
A check mark indicates a row is selected and will be included in the export results. Click the check box to select or clear a row. You can select individual rows or click Select All to select all the records in the table. |
Timesheet Class | This field displays the employee timesheet class description. |
Processing
When you have entered the timesheet selection information, you can process and export the records.
Field | Description |
---|---|
Process |
Click to collect the timesheet data to be exported. When you click , Time & Expense marks timesheets as unavailable if the timesheets meet the selection criteria. As a result, the timesheets cannot be changed while the process is ongoing. This process also updates the appropriate staging tables with the collected timesheet information. Note: If processing fails for a batch, all updates revert automatically. Additionally, any timesheets rejected by Costpoint are not marked as processed.
|